Usage Note 33487: Options to enable full SQL logging in SAS® 9.1.3 when the SAS® OLAP Server accesses DBMS tables
When accessing a relational DBMS table via a SAS OLAP cube (for example, the DBMS table is the cube's NWAY), you might not see the full set of SQL statements that are processed.
Included below are suggested SAS system option settings to enable at the invocation of your SAS OLAP Server to allow more complete logging of SQL statements involved in the cube query.
-sastrace ",,,d"
-sastraceloc file 'c:\temp\OLAPtrace.log'
-nostsuffix
Below is a sample of the SQL statements logged when the above options are specified for a SAS OLAP Server running on a Windows server.
ORACLE_2: Prepared:
SELECT * FROM ORALIB.OLAP_ORDER_FACT
ORACLE_3: Prepared:
select distinct COUNT(oralib.OLAP_ORDER_FACT."TOTAL_RETAIL_PRICE"),
SUM (oralib.OLAP_ORDER_FACT."TOTAL_RETAIL_PRICE")
from oraglib.OLAP_ORDER_FACT
ORACLE_4: Executed:
SELECT statement ORACLE_3
ACCESS ENGINE: SQL statement was passed to the DBMS for fetching data.
Without these settings specified, only the "ORACLE_n: Executed:" and "ACCESS ENGINE:" statements are captured in the SAS OLAP Server log. No "ORACLE_n: Prepared:" statements are returned.
These options are not necessary for SAS 9.2, which includes enhancements to the logging facility.
Operating System and Release Information
SAS System | SAS OLAP Server | Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M2 | 9.2 TS2M0 |
Microsoft Windows 2000 Advanced Server | 9.1 TS1M2 | |
Microsoft Windows 2000 Datacenter Server | 9.1 TS1M2 | |
Microsoft Windows 2000 Server | 9.1 TS1M2 | |
Microsoft Windows 2000 Professional | 9.1 TS1M2 | |
Microsoft Windows NT Workstation | 9.1 TS1M2 | |
Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M2 | 9.2 TS2M0 |
Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M2 | 9.2 TS2M0 |
Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M2 | 9.2 TS2M0 |
Microsoft Windows XP Professional | 9.1 TS1M2 | 9.2 TS2M0 |
64-bit Enabled AIX | 9.1 TS1M2 | 9.2 TS2M0 |
64-bit Enabled HP-UX | 9.1 TS1M2 | 9.2 TS2M0 |
64-bit Enabled Solaris | 9.1 TS1M2 | 9.2 TS2M0 |
HP-UX IPF | 9.1 TS1M2 | 9.2 TS2M0 |
Linux | 9.1 TS1M2 | 9.2 TS2M0 |
OpenVMS Alpha | 9.1 TS1M2 | 9.2 TS2M0 |
Tru64 UNIX | 9.1 TS1M2 | 9.2 TS2M0 |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M2 | 9.2 TS2M0 |
Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M2 | 9.2 TS2M0 |
z/OS | 9.1 TS1M2 | 9.2 TS2M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
The default configuration for the SAS OLAP Server only logs partial SQL statements processed for queries to a DMBS table. This note has suggested SAS options to enable more complete logging of SQL statements in SAS 9.1.3.
Date Modified: | 2012-05-22 15:19:27 |
Date Created: | 2008-10-01 11:11:00 |